package com.itheima.mapper;

import com.itheima.domain.Office;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OfficeMapper {

    //查询所有科室信息
    @Select("SELECT * FROM office")
    public List<Office> findAll();


    //根据id查询对应的科室信息
    @Select("select * from office where id = #{id}")
    public Office findById(Integer id);

}
